Question1: What is the MINIMUM permission needed to access a file URL from an external stage?
Question2: What is a characteristic of materialized views in Snowflake?
Question3: How can a Snowflake user post-process the result of SHOW FILE FORMATS?
Question4: Which Snowflake function is maintained separately from the data and helps to support features such as Time Travel, Secure Data Sharing, and pruning?
Question5: How long does Snowflake retain information in the ACCESS HISTORY view?
Question6: Which DDL/DML operation is allowed on an inbound data share?
Question7: What does a Notify & Suspend action for a resource monitor do?
Question8: How does a Snowflake user extract the URL of a directory table on an external stage for further transformation?
Question9: When referring to User-Defined Function (UDF) names in Snowflake, what does the term overloading mean?
Question10: Which views are included in the DATA SHARING USAGE schema? (Select TWO).
Question11: What Snowflake role must be granted for a user to create and manage accounts?
Question12: Where would a Snowflake user find information about query activity from 90 days ago?
Question13: Which feature is only available in the Enterprise or higher editions of Snowflake?
Question14: What are advantages clones have over tables created with CREATE TABLE AS SELECT statement? (Choose two.)
Question15: Which of the following describes external functions in Snowflake?
Question16: Which of the following SQL statements will list the version of the drivers currently being used?
Question17: Which statement describes pruning?
Question18: Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)
Question19: How does a scoped URL expire?
Question20: What does a table with a clustering depth of 1 mean in Snowflake?
Question21: Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)
Question22: Which data types optimally store semi-structured data? (Select TWO).
Question23: Which statement MOST accurately describes clustering in Snowflake?
Question24: Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?
Question25: Which of the following can be executed/called with Snowpipe?
Question26: Which of the following compute resources or features are managed by Snowflake? (Select TWO).
Question27: Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?
Question28: At what level is the MIN_DATA_RETENTION_TIME_IN_DAYS parameter set?
Question29: A Snowflake user is trying to load a 125 GB file using SnowSQL. The file continues to load for almost an entire day. What will happen at the 2< hour mark?
Question30: What happens when a cloned table is replicated to a secondary database? (Select TWO)
Question31: What is the MAXIMUM size limit for a record of a VARIANT data type?
Question32: How can a data provider ensure that a data consumer is going to have access to the required objects?
Question33: Which of the following statements describe features of Snowflake data caching? (Choose two.)
Question34: Which data type can store more than one type of data structure?
Question35: What happens when a virtual warehouse is resized?
Question36: Which Snowflake data governance feature can support auditing when a user query reads column data?
Question37: In the Snowflake access control model, which entity owns an object by default?
Question38: Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?
Question39: User1, who has the SYSADMIN role, executed a query on Snowsight. User2, who is in the same Snowflake account, wants to view the result set of the query executed by User1 using the Snowsight query history.
What will happen if User2 tries to access the query history?
Question40: In the Data Exchange, who can get or request data from the listings? (Select TWO).
Question41: Which Snowflake function will parse a JSON-null into a SQL-null?
Question42: Users are responsible for data storage costs until what occurs?
Question43: How often are the Account and Table master keys automatically rotated by Snowflake?
Question44: Which kind of Snowflake table stores file-level metadata for each file in a stage?
Question45: Which cache type is used to cache data output from SQL queries?
Question46: Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?
Question47: What type of columns does Snowflake recommend to be used as clustering keys? (Select TWO).
Question48: How can an administrator check for updates (for example, SCIM API requests) sent to Snowflake by the identity provider?
Question49: Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?
Question50: What is the difference between a stored procedure and a User-Defined Function (UDF)?
Question51: Which Snowflake object can be accessed in he FROM clause of a query, returning a set of rows having one or more columns?
Question52: At what levels can a resource monitor be configured? (Select TWO).
Question53: What do temporary and transient tables have m common in Snowflake? (Select TWO).
Question54: The Snowflake cloud services layer is responsible for which tasks? (Choose two.)
Question55: What feature of Snowflake Continuous Data Protection can be used for maintenance of historical data?
Question56: Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)
Question57: Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?
Question58: What affects whether the query results cache can be used?
Question59: How long is a query visible in the Query History page in the Snowflake Web Interface (Ul)?
Question60: What are characteristics of reader accounts in Snowflake? (Select TWO).
Question61: What does a masking policy consist of in Snowflake?
Question62: Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)
Question63: True or False: Snowpipe via REST API can only reference External Stages as source.
Question64: Which URL type allows users to access unstructured data without authenticating into Snowflake or passing an authorization token?
Question65: What is the recommended way to change the existing file format type in my format from CSV to JSON?
Question66: A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access?
Question67: A user wants to access files stored in a stage without authenticating into Snowflake. Which type of URL should be used?
Question68: True or False: Fail-safe can be disabled within a Snowflake account.
Question69: Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)
Question70: Which SQL command can be used to verify the privileges that are granted to a role?
Question71: What command is used to export or unload data from Snowflake?
Question72: What does the TableScan operator represent in the Query Profile?
Question73: How often are encryption keys automatically rotated by Snowflake?
Question74: A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option What does the STRIP_OUTER_ARRAY file format do?
Question75: Which of the following are characteristics of security in Snowflake?
Question76: A running virtual warehouse is suspended.
What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?
Question77: Which statements describe benefits of Snowflake's separation of compute and storage? (Select TWO).
Question78: Where can a user find and review the failed logins of a specific user for the past 30 days?
Question79: What are two ways to create and manage Data Shares in Snowflake? (Choose two.)
Question80: Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?
Question81: By default, which role has access to the SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function?
Question82: Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).
Question83: A Snowflake user wants to optimize performance for a query that queries only a small number of rows in a table. The rows require significant processing. The data in the table does not change frequently.
What should the user do?
Question84: Which statement describes how Snowflake supports reader accounts?
Question85: Which privilege is required to use the search optimization service in Snowflake?
Question86: If a virtual warehouse is suspended, what happens to the warehouse cache?
Question87: For the ALLOWED VALUES tag property, what is the MAXIMUM number of possible string values for a single tag?
Question88: What is a responsibility of Snowflake's virtual warehouses?
Question89: Which function unloads data from a relational table to JSON?
Question90: What are the main differences between the account usage views and the information schema views? (Select TWO).
Question91: How long is Snowpipe data load history retained?
Question92: In which scenarios would a user have to pay Cloud Services costs? (Select TWO).
Question93: What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?
Question94: Which Snowflake object contains all the information required to share a database?
Question95: What type of query benefits the MOST from search optimization?
Question96: By default, how long is the standard retention period for Time Travel across all Snowflake accounts?
Question97: A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days. Which of the following statements will return the required information?
Question98: What will happen if a Snowflake user increases the size of a suspended virtual warehouse?
Question99: True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.
Question100: What computer language can be selected when creating User-Defined Functions (UDFs) using the Snowpark API?
Question101: Which common query problems are identified by the Query Profile? (Select TWO.)
Question102: Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)
Question103: What statistical information in a Query Profile indicates that the query is too large to fit in memory? (Select TWO).
Question104: Which commands are restricted in owner's rights stored procedures? (Select TWO).
Question105: How are network policies defined in Snowflake?
Question106: What is the default File Format used in the COPY command if one is not specified?
Question107: Which query contains a Snowflake hosted file URL in a directory table for a stage named bronzestage?
Question108: Using variables in Snowflake is denoted by using which SQL character?
Question109: A tabular User-Defined Function (UDF) is defined by specifying a return clause that contains which keyword?
Question110: What does Snowflake recommend regarding database object ownership? (Select TWO).
Question111: A user has unloaded data from Snowflake to a stage
Which SQL command should be used to validate which data was loaded into the stage?
Question112: What does Snowflake recommend for a user assigned the ACCOUNTADMIN role?
Question113: Where is Snowflake metadata stored?
Question114: True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.
Question115: What privilege should a user be granted to change permissions for new objects in a managed access schema?
Question116: How does Snowflake reorganize data when it is loaded? (Select TWO).
Question117: Which table function should be used to view details on a Directed Acyclic Graphic (DAG) run that is presently scheduled or is executing?
Question118: What are key characteristics of virtual warehouses in Snowflake? (Select TWO).
Question119: What is a directory table in Snowflake?
Question120: When unloading data with the COPY into <location> command, what is the purpose of the PARTITION BY
<expression> parameter option?
Question121: Query parsing and compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?
Question122: Which of the following describes the Snowflake Cloud Services layer?
Question123: A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used. The following COPY INTO command was executed:
COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)
The load failed with this error:
Max LOB size (16777216) exceeded, actual size of parsed column is 17894470.
How can this issue be resolved?
Question124: What is one of the characteristics of data shares?
Question125: A user unloaded a Snowflake table called mytable to an internal stage called mystage.
Which command can be used to view the list of files that has been uploaded to the staged?
Question126: If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?
Question127: Which statements reflect valid commands when using secondary roles? (Select TWO).
Question128: When floating-point number columns are unloaded to CSV or JSON files, Snowflake truncates the values to approximately what?
Question129: What is the minimum Snowflake edition required to create a materialized view?
Question130: Which operation can be performed on Snowflake external tables?
Question131: Which feature is integrated to support Multi-Factor Authentication (MFA) at Snowflake?
Question132: How does the Access_History view enhance overall data governance pertaining to read and write operations?
(Select TWO).
Question133: Which command removes a role from another role or a user in Snowflak?
Question134: How does a Snowflake stored procedure compare to a User-Defined Function (UDF)?
Question135: When would Snowsight automatically detect if a target account is in a different region and enable cross-cloud auto-fulfillment?
Question136: Which task is supported by the use of Access History in Snowflake?
Question137: What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?
Question138: What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)
Question139: A view is defined on a permanent table. A temporary table with the same name is created in the same schema as the referenced table. What will the query from the view return?
Question140: How can a Snowflake administrator determine which user has accessed a database object that contains sensitive information?
Question141: What is a limitation of a Materialized View?
Question142: Based on Snowflake recommendations, when creating a hierarchy of custom roles, the top-most custom role should be assigned to which role?
Question143: A company needs to allow some users to see Personally Identifiable Information (PII) while limiting other users from seeing the full value of the PII.
Which Snowflake feature will support this?
Question144: Which Snowflake feature records changes mace to a table so actions can be taken using that change data capture?
Question145: What value provides information about disk usage for operations where intermediate results do not fit in memory in a Query Profile?
Question146: What type of account can be used to share data with a consumer who does have a Snowflake account?
Question147: Which typos of charts does Snowsight support? (Select TWO).
Question148: Which user object property requires contacting Snowflake Support in order to set a value for it?
Question149: When does a materialized view get suspended in Snowflake?
Question150: When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?
Question151: Which of the following can be used when unloading data from Snowflake? (Choose two.)
Question152: Which command can be used to stage local files from which Snowflake interface?
Question153: Which features could be used to improve the performance of queries that return a small subset of rows from a large table? (Select TWO).
Question154: For Directory tables, what stage allows for automatic refreshing of metadata?
Question155: How does Snowflake define i1s approach to Discretionary Access Control (DAC)?
Question156: Which SQL command can be used to see the CREATE definition of a masking policy?
Question157: What is true about sharing data in Snowflake? (Choose two.)
Question158: A Snowflake account has activated federated authentication.
What will occur when a user with a password that was defined by Snowflake attempts to log in to Snowflake?
Question159: Which Snowflake table objects can be shared with other accounts? (Select TWO).
Question160: How long is the Fail-safe period for temporary and transient tables?
Question161: What operations can be performed while loading a simple CSV file into a Snowflake table using the COPY INTO command? (Select TWO).
Question162: What information does the Query Profile provide?
Question163: Which types of subqueries does Snowflake support? (Select TWO).
Question164: A virtual warehouse is created using the following command:
Create warehouse my_WH with
warehouse_size = MEDIUM
min_cluster_count = 1
max_cluster_count = 1
auto_suspend = 60
auto_resume = true;
The image below is a graphical representation of the warehouse utilization across two days.
What action should be taken to address this situation?
Question165: What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake?
(Choose two.)
Question166: A user created a new worksheet within the Snowsight Ul and wants to share this with teammates How can this worksheet be shared?
Question167: What happens when a network policy includes values that appear in both the allowed and blocked IP address list?
Question168: Which Snowflake object helps evaluate virtual warehouse performance impacted by query queuing?
Question169: Which Snowflow object does not consume and storage costs?
Question170: True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.
Question171: Which Snowflake data types can be used to build nested hierarchical data? (Select TWO)
Question172: What impacts the credit consumption of maintaining a materialized view? (Choose two.)
Question173: When is the result set cache no longer available? (Select TWO)
Question174: If a Snowflake user decides a table should be clustered, what should be used as the cluster key?
Question175: In which Snowflake layer does Snowflake reorganize data into its internal optimized, compressed, columnar format?
Question176: What type of query will benefit from the query acceleration service?
Question177: Which virtual warehouse consideration can help lower compute resource credit consumption?
Question178: Which feature allows a user the ability to control the organization of data in a micro-partition?
Question179: The property mins_to_bypass_network_policy is set at which level?
Question180: What is cached during a query on a virtual warehouse?
Question181: Which command is used to unload files from an internal or external stage to a local file system?
Question182: What compute resource is used when loading data using Snowpipe?
Question183: How many network policies can be assigned to an account or specific user at a time?
Question184: Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?
Question185: The Snowflake Cloud Data Platform is described as having which of the following architectures?
Question186: Which file format will keep floating-point numbers from being truncated when data is unloaded?
Question187: Which command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage?
Question188: What is used to diagnose and troubleshoot network connections to Snowflake?
Question189: When enabling access to unstructured data, which URL permits temporary access to a staged file without the need to grant privileges to the stage or to issue access tokens?
Question190: What is the MAXIMUM Time Travel retention period for a transient table?
Question191: Which command can be used to load data files into a Snowflake stage?
Question192: Snowflake users can create a resource monitor at which levels? (Select TWO).
Question193: How can a user improve the performance of a single large complex query in Snowflake?
Question194: Which commands can only be executed using SnowSQL? (Select TWO).
Question195: What can a Snowflake user do in the Admin area of Snowsight?
Question196: Files have been uploaded to a Snowflake internal stage. The files now need to be deleted.
Which SQL command should be used to delete the files?
Question197: What metadata does Snowflake store for rows in micro-partitions? (Select TWO).
Question198: Will data cached in a warehouse be lost when the warehouse is resized?
Question199: What is the relationship between a Query Profile and a virtual warehouse?
Question200: What function can be used with the recursive argument to return a list of distinct key names in all nested elements in an object?
Question201: How many days is load history for Snowpipe retained?
Question202: What information is stored in the ACCESS_HlSTORY view?
Question203: If a virtual warehouse runs for 61 seconds, shuts down, and then restarts and runs for 30 seconds, for how many seconds is it billed?
Question204: What activities can a user with the ORGADMIN role perform? (Select TWO).
Question205: Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)
Question206: Which Snowflake privilege is required on a pipe object to pause or resume pipes?
Question207: What is it called when a customer managed key is combined with a Snowflake managed key to create a composite key for encryption?
Question208: What should be considered when deciding to use a secure view? (Select TWO).
Question209: For which use cases is running a virtual warehouse required? (Select TWO).
Question210: What is the purpose of the STRIP NULL_VALUES file format option when loading semi-structured data files into Snowflake?
Question211: True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.
Question212: How does the search optimization service help Snowflake users improve query performance?
Question213: Which of the following accurately describes shares?
Question214: How do secure views compare to non-secure views in Snowflake?
Question215: Which function should be used to find the query ID of the second query executed in a current session?
Question216: What is the purpose of an External Function?
Question217: Which type of join will list a I rows in the specified table, even if those rows have no match in the other table?
Question218: Which Snowflake edition enables data sharing only through Snowflake Support?
Question219: Which Snowflake tool is recommended for data batch processing?
Question220: How can a Snowflake user validate data that is unloaded using the COPY INTO <location> command?
Question221: Which function should be used to insert JSON format string data inot a VARIANT field?
Question222: What Snowflake feature provides a data hub for secure data collaboration, with a selected group of invited members?
Question223: What action can a user take to address query concurrency issues?
Question224: In a Snowflake role hierarchy, what is the top-level role?
Question225: The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)
Question226: What can a Snowflake user do with the information included in the details section of a Query Profile?
Question227: Which metadata table will store the storage utilization information even for dropped tables?
Question228: In which hierarchy is tag inheritance possible?
Question229: What is the MINIMUM role required to set the value for the parameter
ENABLE_ACCOUNT_DATABASE_REPLICATION?
Question230: What is the MAXIMUM number of clusters that can be provisioned with a multi-cluster virtual warehouse?
Question231: A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers.
How can this requirement be met?
Question232: How can a row access policy be applied to a table or a view? (Choose two.)
Question233: If a multi-cluster warehouse is using an economy scaling policy, how long will queries wait in the queue before another cluster is started?
Question234: Which key access control concept does Snowflake descibe as a defined level of access to an object?
Question235: Which role has the ability to create a share from a shared database by default?
Question236: What are the least privileges needed to view and modify resource monitors? (Select TWO).
Question237: What is the MOST performant file format for loading data in Snowflake?
Question238: From what stage can a Snowflake user omit the FROM clause while loading data into a table?
Question239: Which Snowflake feature is used for both querying and restoring data?
Question240: Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).
Question241: The Snowflake Search Optimization Services supports improved performance of which kind of query?
Question242: Why would a Snowflake user decide to use a materialized view instead of a regular view?
Question243: What objects in Snowflake are supported by Dynamic Data Masking? (Select TWO).'
Question244: Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?
Question245: What are benefits of using Snowpark with Snowflake? (Select TWO).
Question246: What technique does Snowflake use to limit the number of micro-partitions scanned by each query?
Question247: Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?
Question248: A user wants to access stored in a stage without authenticating into Snowflake.
Which type of URL should be used?
Question249: Which services does the Snowflake Cloud Services layer manage? (Select TWO).
Question250: Which of the following are handled by the cloud services layer of the Snowflake architecture? (Choose two.)
Question251: A sales table FCT_SALES has 100 million records.
The following Query was executed
SELECT COUNT (1) FROM FCT__SALES;
How did Snowflake fulfill this query?
Question252: Which data types are supported by Snowflake when using semi-structured data? (Choose two.)
Question253: Which service or feature in Snowflake is used to improve the performance of certain types of lookup and analytical queries that use an extensive set of WHERE conditions?
Question254: Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)
Question255: Which task privilege does a Snowflake role need in order to suspend or resume a task?
Question256: Which parameter can be set at the account level to set the minimum number of days for which Snowflake retains historical data in Time Travel?
Question257: How can a Snowflake user access a JSON object, given the following table? (Select TWO).
Question258: What are characteristics of transient tables in Snowflake? (Select TWO).
Question259: Which Snowflake object does not consume any storage costs?
Question260: What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?
Question261: Which statement is true about running tasks in Snowflake?
Question262: Snowflake's access control framework combines which models for securing data? (Select TWO).
Question263: A Snowflake user is writing a User-Defined Function (UDF) that includes some unqualified object names.
How will those object names be resolved during execution?
Question264: Which of the following are benefits of micro-partitioning? (Select TWO)
Question265: Which Snowflake feature provides increased login security for users connecting to Snowflake that is powered by Duo Security service?
Question266: What are characteristic of Snowsight worksheet? (Select TWO.)
Question267: Which data type can be used to store geospatial data in Snowflake?
Question268: When using the ALLOW_CLIENT_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?
Question269: Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)
Question270: Authorization to execute CREATE <object> statements comes only from which role?
Question271: Which Snowflake URL type is used by directory tables?
Question272: Which TABLE function helps to convert semi-structured data to a relational representation?
Question273: How does Snowflake handle the bulk unloading of data into single or multiple files?
Question274: Which Snowflake URL type allows users or applications to download or access files directly from Snowflake stage without authentication?
Question275: How many resource monitors can be assigned at the account level?
Question276: What is the MINIMUM size of a table for which Snowflake recommends considering adding a clustering key?
Question277: In which use cases does Snowflake apply egress charges?
Question278: What feature can be used to reorganize a very large table on one or more columns?
Question279: User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW.
Which command will show all privileges granted to that schema?
Question280: How can a Snowflake user traverse semi-structured data?
Question281: How does Snowflake Fail-safe protect data in a permanent table?
Question282: How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?
Question283: A JSON document is stored in the source_colum of type VARIANT. The document has an array called elements. The array contains the name key that has a string value How can a Snowflake user extract the name from the first element?
Question284: Which Snowflake edition offers the highest level of security for organizations that have the strictest requirements?
Question285: How do Snowflake data providers share data that resides in different databases?
Question286: Regardless of which notation is used, what are considerations for writing the column name and element names when traversing semi-structured data?
Question287: The first user assigned to a new account, ACCOUNTADMIN, should create at least one additional user with which administrative privilege?
Question288: Which solution improves the performance of point lookup queries that return a small number of rows from large tables using highly selective filters?
Question289: What is the name of the SnowSQLfile that can store connection information?
Question290: What is the default value in the Snowflake Web Interface (Ul) for auto suspending a Virtual Warehouse?
Question291: When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?
Question292: Which objects together comprise a namespace in Snowflake? (Select TWO).
Question293: What is the minimum Snowflake edition needed for database failover and fail-back between Snowflake accounts for business continuity and disaster recovery?
Question294: A JSON object is loaded into a column named data using a Snowflake variant datatype. The root node of the object is BIKE. The child attribute for this root node is BIKEID.
Which statement will allow the user to access BIKEID?
Question295: What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)
Question296: The VALIDATE table function has which parameter as an input argument for a Snowflake user?